Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_SCHEDULER_CHAINS

`ALL_SCHEDULER_CHAINS` shows all chains visible to the current user (that is, those chains that the user has ALTER or EXECTUE privileges for).

Related Views

- `DBA_SCHEDULER_CHAINS` shows all chains in the database.

- `USER_SCHEDULER_CHAINS` shows all chains in the current user's schema. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owning schema
`CHAIN_NAME` | `VARCHAR2(30)` | `NOT NULL` | Unique user-specified name
`RULE_SET_OWNER` | `VARCHAR2(30)` |  | Owning schema of the rule set describing the dependencies
`RULE_SET_NAME` | `VARCHAR2(30)` |  | Name of the rule set describing the dependencies
`NUMBER_OF_RULES` | `NUMBER` |  | Number of rules in the chain
`NUMBER_OF_STEPS` | `NUMBER` |  | Number of steps in the chain
`ENABLED` | `VARCHAR2(5)` |  | Whether or not the chain is enabled
`EVALUATION_INTERVAL` | `INTERVAL DAY(3) TO SECOND(0)` |  | Periodic interval at which to evaluate rules for this chain
`USER_RULE_SET` | `VARCHAR2(5)` |  | Whether or not the chain has a user-specified rule set
`COMMENTS` | `VARCHAR2(240)` |  | User comments